<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.15" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 2.2.2.r222_v20071226 Build &lt;2.2.2.v20080226-1155></property>
    <property name="units">in</property>
    <property name="comments">Copyright (c) 2007 &lt;&lt;Your Company Name here>></property>
    <html-property name="description">Creates a blank report with no predefined content.</html-property>
    <text-property name="displayName">Blank Report</text-property>
    <property name="iconFile">/templates/blank_report.gif</property>
    <data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="6">
            <property name="odaDriverClass">com.mysql.jdbc.Driver</property>
            <property name="odaURL">jdbc:mysql://localhost:3306/academix</property>
            <property name="odaUser">root</property>
            <encrypted-property name="odaPassword" encryptionID="base64">cm9vdDEyMw==</encrypted-property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Lista Presenca - Data Set" id="7">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">des_campus</property>
                    <property name="displayName">des_campus</property>
                </structure>
                <structure>
                    <property name="columnName">nom_curso</property>
                    <property name="displayName">nom_curso</property>
                </structure>
                <structure>
                    <property name="columnName">num_ano</property>
                    <property name="displayName">num_ano</property>
                </structure>
                <structure>
                    <property name="columnName">num_semestre</property>
                    <property name="displayName">num_semestre</property>
                </structure>
                <structure>
                    <property name="columnName">num_periodo_vigente</property>
                    <property name="displayName">num_periodo_vigente</property>
                </structure>
                <structure>
                    <property name="columnName">cod_turma</property>
                    <property name="displayName">cod_turma</property>
                </structure>
                <structure>
                    <property name="columnName">nom_disciplina</property>
                    <property name="displayName">nom_disciplina</property>
                </structure>
                <structure>
                    <property name="columnName">num_ra</property>
                    <property name="displayName">num_ra</property>
                </structure>
                <structure>
                    <property name="columnName">nom_aluno</property>
                    <property name="displayName">nom_aluno</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">des_campus</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">nom_curso</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">num_ano</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">num_semestre</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">num_periodo_vigente</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">cod_turma</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">nom_disciplina</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">num_ra</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">nom_aluno</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">des_campus</property>
                    <property name="nativeName">des_campus</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">nom_curso</property>
                    <property name="nativeName">nom_curso</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">num_ano</property>
                    <property name="nativeName">num_ano</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">num_semestre</property>
                    <property name="nativeName">num_semestre</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">num_periodo_vigente</property>
                    <property name="nativeName">num_periodo_vigente</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">cod_turma</property>
                    <property name="nativeName">cod_turma</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">nom_disciplina</property>
                    <property name="nativeName">nom_disciplina</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">num_ra</property>
                    <property name="nativeName">num_ra</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">nom_aluno</property>
                    <property name="nativeName">nom_aluno</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
            </list-property>
            <property name="queryText">SELECT 	 cp.des_campus,
		 cs.nom_curso,
		 gd.num_ano,
		 gd.num_semestre,
		 gd.num_periodo_vigente,
		 tm.cod_turma,
		 dc.nom_disciplina,
		 al.num_ra,
		 al.nom_aluno
FROM     academix.campus cp,
         academix.curso cs,
         academix.grade_curricular gd,
         academix.disc_grade_curricular dg,
         academix.disciplina dc,
		 academix.turma tm,
		 academix.aluno_turma at,
		 academix.aluno al
where    cp.idt_campus = cs.ind_campus
and      cs.idt_curso = gd.ind_curso
and      dg.ind_grade_curricular = gd.idt_grade_curricular
and      dc.idt_disciplina = dg.ind_disciplina
and      gd.idt_grade_curricular = tm.ind_grade_curricular
and      tm.idt_turma = at.ind_turma
and      al.idt_aluno = at.ind_aluno
order by tm.cod_turma,
		 dc.nom_disciplina,
		 al.nom_aluno</property>
        </oda-data-set>
    </data-sets>
    <styles>
        <style name="crosstab-cell" id="4">
            <property name="borderBottomColor">#CCCCCC</property>
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">1pt</property>
            <property name="borderLeftColor">#CCCCCC</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">1pt</property>
            <property name="borderRightColor">#CCCCCC</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">1pt</property>
            <property name="borderTopColor">#CCCCCC</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">1pt</property>
        </style>
        <style name="crosstab" id="5">
            <property name="borderBottomColor">#CCCCCC</property>
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">1pt</property>
            <property name="borderLeftColor">#CCCCCC</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">1pt</property>
            <property name="borderRightColor">#CCCCCC</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">1pt</property>
            <property name="borderTopColor">#CCCCCC</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">1pt</property>
        </style>
    </styles>
    <page-setup>
        <simple-master-page name="Simple MasterPage" id="2"/>
    </page-setup>
    <body>
        <list id="8">
            <property name="pageBreakAfter">avoid</property>
            <property name="pageBreakBefore">avoid</property>
            <property name="dataSet">Lista Presenca - Data Set</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">des_campus</property>
                    <expression name="expression">dataSetRow["des_campus"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">nom_curso</property>
                    <expression name="expression">dataSetRow["nom_curso"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">num_ano</property>
                    <expression name="expression">dataSetRow["num_ano"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">num_semestre</property>
                    <expression name="expression">dataSetRow["num_semestre"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">num_periodo_vigente</property>
                    <expression name="expression">dataSetRow["num_periodo_vigente"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">cod_turma</property>
                    <expression name="expression">dataSetRow["cod_turma"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">nom_disciplina</property>
                    <expression name="expression">dataSetRow["nom_disciplina"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">num_ra</property>
                    <expression name="expression">dataSetRow["num_ra"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">nom_aluno</property>
                    <expression name="expression">dataSetRow["nom_aluno"]</expression>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <group id="98">
                <property name="groupName">Turma</property>
                <property name="interval">none</property>
                <property name="sortDirection">asc</property>
                <expression name="keyExpr">row["cod_turma"]</expression>
                <structure name="toc">
                    <expression name="expressionValue">row["cod_turma"]</expression>
                </structure>
                <property name="repeatHeader">true</property>
                <property name="hideDetail">false</property>
                <property name="pageBreakAfter">auto</property>
                <property name="pageBreakBefore">auto</property>
                <property name="pageBreakInside">auto</property>
            </group>
            <group id="101">
                <property name="groupName">Disciplina</property>
                <property name="interval">none</property>
                <property name="sortDirection">asc</property>
                <expression name="keyExpr">row["nom_disciplina"]</expression>
                <structure name="toc">
                    <expression name="expressionValue">row["nom_disciplina"]</expression>
                </structure>
                <property name="repeatHeader">true</property>
                <property name="hideDetail">false</property>
                <property name="pageBreakAfter">auto</property>
                <property name="pageBreakBefore">always</property>
                <property name="pageBreakInside">auto</property>
                <header>
                    <grid id="23">
                        <property name="marginTop">0pt</property>
                        <property name="width">100%</property>
                        <column id="24">
                            <property name="width">1.0833333333in</property>
                        </column>
                        <column id="25">
                            <property name="width">2.53125in</property>
                        </column>
                        <column id="26"/>
                        <column id="27"/>
                        <row id="28">
                            <cell id="29">
                                <label id="49">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">Curso:</text-property>
                                </label>
                            </cell>
                            <cell id="30">
                                <data id="50">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="dataSet">Lista Presenca - Data Set</property>
                                    <list-property name="boundDataColumns">
                                        <structure>
                                            <property name="name">des_campus</property>
                                            <expression name="expression">dataSetRow["des_campus"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">num_ano</property>
                                            <expression name="expression">dataSetRow["num_ano"]</expression>
                                            <property name="dataType">integer</property>
                                        </structure>
                                        <structure>
                                            <property name="name">num_semestre</property>
                                            <expression name="expression">dataSetRow["num_semestre"]</expression>
                                            <property name="dataType">integer</property>
                                        </structure>
                                        <structure>
                                            <property name="name">num_periodo_vigente</property>
                                            <expression name="expression">dataSetRow["num_periodo_vigente"]</expression>
                                            <property name="dataType">integer</property>
                                        </structure>
                                        <structure>
                                            <property name="name">nom_curso</property>
                                            <expression name="expression">dataSetRow["nom_curso"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">cod_turma</property>
                                            <expression name="expression">dataSetRow["cod_turma"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">num_ra</property>
                                            <expression name="expression">dataSetRow["num_ra"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                        <structure>
                                            <property name="name">nom_aluno</property>
                                            <expression name="expression">dataSetRow["nom_aluno"]</expression>
                                            <property name="dataType">string</property>
                                        </structure>
                                    </list-property>
                                    <property name="resultSetColumn">nom_curso</property>
                                </data>
                            </cell>
                            <cell id="31"/>
                            <cell id="32"/>
                        </row>
                        <row id="33">
                            <cell id="34">
                                <label id="51">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">Ano:</text-property>
                                </label>
                            </cell>
                            <cell id="35">
                                <data id="55">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="resultSetColumn">num_ano</property>
                                </data>
                            </cell>
                            <cell id="36">
                                <label id="52">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">Semestre:</text-property>
                                </label>
                            </cell>
                            <cell id="37">
                                <data id="56">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="resultSetColumn">num_semestre</property>
                                </data>
                            </cell>
                        </row>
                        <row id="38">
                            <cell id="39">
                                <label id="53">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">Periodo Vigente:</text-property>
                                </label>
                            </cell>
                            <cell id="40">
                                <data id="57">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="resultSetColumn">num_periodo_vigente</property>
                                </data>
                            </cell>
                            <cell id="41">
                                <label id="58">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">Turma:</text-property>
                                </label>
                            </cell>
                            <cell id="42">
                                <data id="59">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="resultSetColumn">cod_turma</property>
                                </data>
                            </cell>
                        </row>
                        <row id="43">
                            <cell id="44">
                                <label id="103">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">Disciplina:</text-property>
                                </label>
                            </cell>
                            <cell id="45">
                                <data id="102">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="resultSetColumn">nom_disciplina</property>
                                </data>
                            </cell>
                            <cell id="46"/>
                            <cell id="47"/>
                        </row>
                    </grid>
                    <grid id="84">
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">1px</property>
                        <property name="width">100%</property>
                        <column id="85"/>
                        <column id="86"/>
                        <column id="87"/>
                        <row id="88">
                            <cell id="89">
                                <property name="width">10mm</property>
                                <property name="borderLeftColor">#000000</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">1px</property>
                                <property name="borderRightColor">#000000</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">1px</property>
                                <property name="paddingTop">1pt</property>
                                <label id="92">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="fontWeight">bold</property>
                                    <property name="marginTop">0pt</property>
                                    <text-property name="text">RA</text-property>
                                </label>
                            </cell>
                            <cell id="90">
                                <property name="borderLeftColor">#000000</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">1px</property>
                                <property name="borderRightColor">#000000</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">1px</property>
                                <label id="93">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="fontWeight">bold</property>
                                    <text-property name="text">Nome</text-property>
                                </label>
                            </cell>
                            <cell id="91">
                                <property name="borderLeftColor">#000000</property>
                                <property name="borderLeftStyle">solid</property>
                                <property name="borderLeftWidth">1px</property>
                                <property name="borderRightColor">#000000</property>
                                <property name="borderRightStyle">solid</property>
                                <property name="borderRightWidth">1px</property>
                                <label id="94">
                                    <property name="fontFamily">"Arial"</property>
                                    <property name="fontWeight">bold</property>
                                    <property name="textAlign">center</property>
                                    <text-property name="text">Assinatura</text-property>
                                </label>
                            </cell>
                        </row>
                    </grid>
                </header>
                <footer>
                    <grid id="104">
                        <property name="width">100%</property>
                        <column id="105"/>
                        <column id="106"/>
                        <column id="107"/>
                        <row id="108">
                            <cell id="109">
                                <property name="width">10mm</property>
                                <property name="borderTopColor">#000000</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">1px</property>
                            </cell>
                            <cell id="111">
                                <property name="borderTopColor">#000000</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">1px</property>
                            </cell>
                            <cell id="113">
                                <property name="borderTopColor">#000000</property>
                                <property name="borderTopStyle">solid</property>
                                <property name="borderTopWidth">1px</property>
                            </cell>
                        </row>
                    </grid>
                </footer>
            </group>
            <detail>
                <grid id="73">
                    <property name="width">100%</property>
                    <column id="74"/>
                    <column id="75"/>
                    <column id="76"/>
                    <row id="77">
                        <cell id="78">
                            <property name="width">10mm</property>
                            <property name="borderLeftColor">#000000</property>
                            <property name="borderLeftStyle">solid</property>
                            <property name="borderLeftWidth">1px</property>
                            <property name="borderRightColor">#000000</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">1px</property>
                            <property name="borderTopColor">#000000</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">1px</property>
                            <data id="81">
                                <property name="fontFamily">"Arial"</property>
                                <property name="marginTop">0pt</property>
                                <property name="resultSetColumn">num_ra</property>
                            </data>
                        </cell>
                        <cell id="79">
                            <property name="borderRightColor">#000000</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">1px</property>
                            <property name="borderTopColor">#000000</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">1px</property>
                            <data id="82">
                                <property name="fontFamily">"Arial"</property>
                                <property name="resultSetColumn">nom_aluno</property>
                            </data>
                        </cell>
                        <cell id="80">
                            <property name="borderRightColor">#000000</property>
                            <property name="borderRightStyle">solid</property>
                            <property name="borderRightWidth">1px</property>
                            <property name="borderTopColor">#000000</property>
                            <property name="borderTopStyle">solid</property>
                            <property name="borderTopWidth">1px</property>
                        </cell>
                    </row>
                </grid>
            </detail>
        </list>
    </body>
</report>
